CREATE TABLE [dbo].[JOL_SurveyManagement_Respond]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[item] [int] NULL,
[selected] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[respondent] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[respond_time] [smalldatetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_SurveyManagement_Respond] ADD CONSTRAINT [PK_JOL_SurveyManagement_Respond] PRIMARY KEY CLUSTERED  ([id]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'对应调查项的id', 'SCHEMA', N'dbo', 'TABLE', N'JOL_SurveyManagement_Respond', 'COLUMN', N'item'
GO
EXEC sp_addextendedproperty N'MS_Description', N'作答时间', 'SCHEMA', N'dbo', 'TABLE', N'JOL_SurveyManagement_Respond', 'COLUMN', N'respond_time'
GO
EXEC sp_addextendedproperty N'MS_Description', N'作答人', 'SCHEMA', N'dbo', 'TABLE', N'JOL_SurveyManagement_Respond', 'COLUMN', N'respondent'
GO
EXEC sp_addextendedproperty N'MS_Description', N'选定的选项', 'SCHEMA', N'dbo', 'TABLE', N'JOL_SurveyManagement_Respond', 'COLUMN', N'selected'
GO
